ocr: category shrunken aggregate Product category Sales fact table dimension table time dimensiont table time key category key category_key category store dimension.table: store. key department promo key promo dimension table gtysold doliars sold dollars cost FIGURE 3 The same data warehouse showing the ag- gregates in a separate category aggregate fact table and a shrunken product category dimension table.
